package com.example.entity.excel;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.joda.time.LocalDate;

import java.util.Date;
@ApiModel(value = "销售订单Excel")
@Data
public class SaleExcel {

    @ExcelIgnore
    @ApiModelProperty(value = "在原Excel中的行号")
//    @ExcelProperty("在原Excel中的行号")
    private int rows;

    @ApiModelProperty(value = "导入状态")
    @ExcelProperty("導入狀態")
    private String importStatus;

    @ApiModelProperty(value = "销售单号")
    @ExcelProperty("銷售單號")
    private String saleOrderId;

    @ApiModelProperty(value = "订单日期")
    @ExcelProperty("訂單日期")
    private String orderDate;

    @ApiModelProperty(value = "客戶訂單")
    @ExcelProperty("客戶訂單")
    private String customOrder;

    @ApiModelProperty(value = "客戶訂單日期")
    @ExcelProperty("客戶訂單日期")
    private String customOrderDate;

    @ApiModelProperty(value = "客戶")
    @ExcelProperty("客戶*")
    private String customId;

    @ApiModelProperty(value = "幣別")
    @ExcelProperty("幣別")
    private String coinType;

    @ApiModelProperty(value = "訂單匯率")
    @ExcelProperty("訂單匯率")
    private String orderExchangeRate;

    @ApiModelProperty(value = "稅別")
    @ExcelProperty("稅別")
    private String taxType;

    @ApiModelProperty(value = "單價含稅")
    @ExcelProperty("單價含稅")
    private String unitPriceIncludesTax;

    @ApiModelProperty(value = "業務員")
    @ExcelProperty("業務員")
    private String salesMan;

    @ApiModelProperty(value = "銷售部門")
    @ExcelProperty("銷售部門")
    private String salesDepartment;

    @ApiModelProperty(value = "付款條件")
    @ExcelProperty("付款條件")
    private String paymentTerms;

    @ApiModelProperty(value = "送貨地址")
    @ExcelProperty("送貨地址")
    private String shippingAddress;

    @ApiModelProperty(value = "發票地址")
    @ExcelProperty("發票地址")
    private String invoiceAddress;

    @ApiModelProperty(value = "發票類型")
    @ExcelProperty("發票類型")
    private String invoiceType;

    @ApiModelProperty(value = "交易條件")
    @ExcelProperty("交易條件")
    private String transactionTerms;

    @ApiModelProperty(value = "專案名稱")
    @ExcelProperty("專案名稱")
    private String projectName;

    @ApiModelProperty(value = "嘜頭")
    @ExcelProperty("嘜頭")
    private String mark;

    @ApiModelProperty(value = "供應鏈訂單")
    @ExcelProperty("供應鏈訂單")
    private String supplyChainOrder;

    @ApiModelProperty(value = "分次開票")
    @ExcelProperty("分次開票")
    private String invoicingInInstallments;

    @ApiModelProperty(value = "備註")
    @ExcelProperty("備註")
    private String headRemark;

    @ApiModelProperty(value = "NO")
    @ExcelProperty("NO")
    private String NO;

    @ApiModelProperty(value = "商品")
    @ExcelProperty("商品*")
    private String commodity;

    @ApiModelProperty(value = "客戶商品")
    @ExcelProperty("客戶商品")
    private String customerMerchandise;

    @ApiModelProperty(value = "單位")
    @ExcelProperty("單位")
    private String unit;

    @ApiModelProperty(value = "數量")
    @ExcelProperty("數量*")
    private String amount;

    @ApiModelProperty(value = "單價")
    @ExcelProperty("單價")
    private String unitPrice;

    @ApiModelProperty(value = "預定交貨日")
    @ExcelProperty("預定交貨日")
    private String scheduledDeliveryDate;

    @ApiModelProperty(value = "運送方式")
    @ExcelProperty("運送方式")
    private String shippingMethod;

    @ApiModelProperty(value = "倉庫")
    @ExcelProperty("倉庫")
    private String storehouse;

    @ApiModelProperty(value = "銷售/代工")
    @ExcelProperty("銷售/代工")
    private String SalesOEM;

    @ApiModelProperty(value = "生管確認日")
    @ExcelProperty("生管確認日")
    private String productionManagementConfirmationDate;

    @ApiModelProperty(value = "備 注")
    @ExcelProperty("備 注")
    private String singleNotes;

    @ApiModelProperty(value = "供應鏈流程")
    @ExcelProperty("供應鏈流程")
    private String supplyChainProcess;

    @ApiModelProperty(value = "備品")
    @ExcelProperty("備品")
    private String spareParts;

    @ApiModelProperty(value = "使用保稅材料")
    @ExcelProperty("使用保稅材料")
    private String useBondedMaterials;

    @ApiModelProperty(value = "分廠")
    @ExcelProperty("分廠")
    private String branchFactory;

    @ApiModelProperty(value = "銷售去向")
    @ExcelProperty("銷售去向")
    private String salesDestination;

    @ApiModelProperty(value = "保稅")
    @ExcelProperty("保稅")
    private String bonded;

}
